Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 10693 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.6 MiB |
| Average record size in memory | 155.0 B |
Variable types
| NUM | 11 |
|---|---|
| DATE | 1 |
| CAT | 1 |
ID is highly correlated with df_index and 1 other fields | High correlation |
df_index is highly correlated with ID and 1 other fields | High correlation |
presion_min is highly correlated with presion_max | High correlation |
presion_max is highly correlated with presion_min | High correlation |
temperatura_max is highly correlated with temperatura_min | High correlation |
temperatura_min is highly correlated with temperatura_max | High correlation |
anio is highly correlated with df_index and 1 other fields | High correlation |
df_index has unique values | Unique |
ID has unique values | Unique |
fecha has unique values | Unique |
precipitacion has 8459 (79.1%) zeros | Zeros |
horas_sol has 665 (6.2%) zeros | Zeros |
Reproduction
| Analysis started | 2021-07-16 10:45:09.462765 |
|---|---|
| Analysis finished | 2021-07-16 10:45:28.927917 |
| Duration | 19.47 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 10693 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5375.533059 |
|---|---|
| Minimum | 0 |
| Maximum | 10774 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 83.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 534.6 |
| Q1 | 2673 |
| median | 5346 |
| Q3 | 8091 |
| 95-th percentile | 10238.4 |
| Maximum | 10774 |
| Range | 10774 |
| Interquartile range (IQR) | 5418 |
Descriptive statistics
| Standard deviation | 3118.866989 |
|---|---|
| Coefficient of variation (CV) | 0.5801967833 |
| Kurtosis | -1.207664656 |
| Mean | 5375.533059 |
| Median Absolute Deviation (MAD) | 2709 |
| Skewness | 0.008941162842 |
| Sum | 57480575 |
| Variance | 9727331.297 |
| Monotocity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 613 | 1 | < 0.1% | |
| 4711 | 1 | < 0.1% | |
| 8809 | 1 | < 0.1% | |
| 2668 | 1 | < 0.1% | |
| 621 | 1 | < 0.1% | |
| 6766 | 1 | < 0.1% | |
| 4719 | 1 | < 0.1% | |
| 8817 | 1 | < 0.1% | |
| 2676 | 1 | < 0.1% | |
| 629 | 1 | < 0.1% | |
| 6774 | 1 | < 0.1% | |
| 4727 | 1 | < 0.1% | |
| 8825 | 1 | < 0.1% | |
| 2684 | 1 | < 0.1% | |
| 637 | 1 | < 0.1% | |
| 6782 | 1 | < 0.1% | |
| 4735 | 1 | < 0.1% | |
| 8833 | 1 | < 0.1% | |
| 6758 | 1 | < 0.1% | |
| 2660 | 1 | < 0.1% | |
| 645 | 1 | < 0.1% | |
| 8801 | 1 | < 0.1% | |
| 6726 | 1 | < 0.1% | |
| 4679 | 1 | < 0.1% | |
| Other values (10668) | 10668 | 99.8% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 10774 | 1 | < 0.1% | |
| 10773 | 1 | < 0.1% | |
| 10772 | 1 | < 0.1% | |
| 10771 | 1 | < 0.1% | |
| 10770 | 1 | < 0.1% | |
| 10769 | 1 | < 0.1% | |
| 10768 | 1 | < 0.1% | |
| 10767 | 1 | < 0.1% | |
| 10766 | 1 | < 0.1% | |
| 10765 | 1 | < 0.1% |
| Distinct | 10693 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5375.533059 |
|---|---|
| Minimum | 0 |
| Maximum | 10774 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 83.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 534.6 |
| Q1 | 2673 |
| median | 5346 |
| Q3 | 8091 |
| 95-th percentile | 10238.4 |
| Maximum | 10774 |
| Range | 10774 |
| Interquartile range (IQR) | 5418 |
Descriptive statistics
| Standard deviation | 3118.866989 |
|---|---|
| Coefficient of variation (CV) | 0.5801967833 |
| Kurtosis | -1.207664656 |
| Mean | 5375.533059 |
| Median Absolute Deviation (MAD) | 2709 |
| Skewness | 0.008941162842 |
| Sum | 57480575 |
| Variance | 9727331.297 |
| Monotocity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 613 | 1 | < 0.1% | |
| 4711 | 1 | < 0.1% | |
| 8809 | 1 | < 0.1% | |
| 2668 | 1 | < 0.1% | |
| 621 | 1 | < 0.1% | |
| 6766 | 1 | < 0.1% | |
| 4719 | 1 | < 0.1% | |
| 8817 | 1 | < 0.1% | |
| 2676 | 1 | < 0.1% | |
| 629 | 1 | < 0.1% | |
| 6774 | 1 | < 0.1% | |
| 4727 | 1 | < 0.1% | |
| 8825 | 1 | < 0.1% | |
| 2684 | 1 | < 0.1% | |
| 637 | 1 | < 0.1% | |
| 6782 | 1 | < 0.1% | |
| 4735 | 1 | < 0.1% | |
| 8833 | 1 | < 0.1% | |
| 6758 | 1 | < 0.1% | |
| 2660 | 1 | < 0.1% | |
| 645 | 1 | < 0.1% | |
| 8801 | 1 | < 0.1% | |
| 6726 | 1 | < 0.1% | |
| 4679 | 1 | < 0.1% | |
| Other values (10668) | 10668 | 99.8% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 10774 | 1 | < 0.1% | |
| 10773 | 1 | < 0.1% | |
| 10772 | 1 | < 0.1% | |
| 10771 | 1 | < 0.1% | |
| 10770 | 1 | < 0.1% | |
| 10769 | 1 | < 0.1% | |
| 10768 | 1 | < 0.1% | |
| 10767 | 1 | < 0.1% | |
| 10766 | 1 | < 0.1% | |
| 10765 | 1 | < 0.1% |
| Distinct | 10693 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 83.7 KiB |
| Minimum | 1992-01-01 00:00:00 |
|---|---|
| Maximum | 2021-07-01 00:00:00 |
Histogram with fixed size bins (bins=50)
| Distinct | 364 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.518731881 |
|---|---|
| Minimum | 0 |
| Maximum | 134.7 |
| Zeros | 8459 |
| Zeros (%) | 79.1% |
| Memory size | 83.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 8.64 |
| Maximum | 134.7 |
| Range | 134.7 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 6.443861419 |
|---|---|
| Coefficient of variation (CV) | 4.242922336 |
| Kurtosis | 88.68439152 |
| Mean | 1.518731881 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.931661091 |
| Sum | 16239.8 |
| Variance | 41.52334998 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 8459 | 79.1% | |
| 0.1 | 145 | 1.4% | |
| 0.2 | 126 | 1.2% | |
| 0.3 | 101 | 0.9% | |
| 0.4 | 87 | 0.8% | |
| 0.6 | 70 | 0.7% | |
| 0.5 | 60 | 0.6% | |
| 0.8 | 50 | 0.5% | |
| 1 | 50 | 0.5% | |
| 1.2 | 45 | 0.4% | |
| 0.7 | 43 | 0.4% | |
| 1.8 | 38 | 0.4% | |
| 1.4 | 35 | 0.3% | |
| 1.1 | 34 | 0.3% | |
| 0.9 | 32 | 0.3% | |
| 1.6 | 30 | 0.3% | |
| 1.3 | 27 | 0.3% | |
| 1.7 | 26 | 0.2% | |
| 1.5 | 23 | 0.2% | |
| 2.2 | 23 | 0.2% | |
| 2 | 22 | 0.2% | |
| 2.8 | 22 | 0.2% | |
| 1.9 | 21 | 0.2% | |
| 2.1 | 19 | 0.2% | |
| 3.8 | 18 | 0.2% | |
| Other values (339) | 1087 | 10.2% |
| Value | Count | Frequency (%) | |
| 0 | 8459 | 79.1% | |
| 0.1 | 145 | 1.4% | |
| 0.2 | 126 | 1.2% | |
| 0.3 | 101 | 0.9% | |
| 0.4 | 87 | 0.8% | |
| 0.5 | 60 | 0.6% | |
| 0.6 | 70 | 0.7% | |
| 0.7 | 43 | 0.4% | |
| 0.8 | 50 | 0.5% | |
| 0.9 | 32 | 0.3% |
| Value | Count | Frequency (%) | |
| 134.7 | 1 | < 0.1% | |
| 124.8 | 1 | < 0.1% | |
| 107.3 | 1 | < 0.1% | |
| 104.9 | 1 | < 0.1% | |
| 97.2 | 1 | < 0.1% | |
| 95.9 | 1 | < 0.1% | |
| 87.9 | 1 | < 0.1% | |
| 78.5 | 1 | < 0.1% | |
| 74.5 | 1 | < 0.1% | |
| 74 | 1 | < 0.1% |
| Distinct | 372 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.719858786 |
|---|---|
| Minimum | 0 |
| Maximum | 13.7 |
| Zeros | 665 |
| Zeros (%) | 6.2% |
| Memory size | 83.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3.8 |
| median | 7.4 |
| Q3 | 9.9 |
| 95-th percentile | 11.7 |
| Maximum | 13.7 |
| Range | 13.7 |
| Interquartile range (IQR) | 6.1 |
Descriptive statistics
| Standard deviation | 3.705533896 |
|---|---|
| Coefficient of variation (CV) | 0.5514303223 |
| Kurtosis | -1.031431104 |
| Mean | 6.719858786 |
| Median Absolute Deviation (MAD) | 2.9 |
| Skewness | -0.3739626869 |
| Sum | 71855.45 |
| Variance | 13.73098145 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 665 | 6.2% | |
| 11 | 151 | 1.4% | |
| 11.4 | 146 | 1.4% | |
| 10.8 | 143 | 1.3% | |
| 9.8 | 141 | 1.3% | |
| 10.2 | 134 | 1.3% | |
| 9 | 132 | 1.2% | |
| 8 | 129 | 1.2% | |
| 10.6 | 128 | 1.2% | |
| 10 | 128 | 1.2% | |
| 11.2 | 126 | 1.2% | |
| 9.2 | 126 | 1.2% | |
| 11.3 | 126 | 1.2% | |
| 8.2 | 123 | 1.2% | |
| 10.4 | 119 | 1.1% | |
| 9.4 | 118 | 1.1% | |
| 10.5 | 116 | 1.1% | |
| 8.8 | 115 | 1.1% | |
| 7.4 | 112 | 1.0% | |
| 7.8 | 112 | 1.0% | |
| 6.8 | 111 | 1.0% | |
| 8.4 | 110 | 1.0% | |
| 11.6 | 109 | 1.0% | |
| 11.5 | 107 | 1.0% | |
| 8.6 | 107 | 1.0% | |
| Other values (347) | 7059 | 66.0% |
| Value | Count | Frequency (%) | |
| 0 | 665 | 6.2% | |
| 0.03333333333 | 1 | < 0.1% | |
| 0.05 | 1 | < 0.1% | |
| 0.06666666667 | 1 | < 0.1% | |
| 0.1 | 69 | 0.6% | |
| 0.15 | 1 | < 0.1% | |
| 0.1666666667 | 1 | < 0.1% | |
| 0.2 | 73 | 0.7% | |
| 0.3 | 62 | 0.6% | |
| 0.3333333333 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 13.7 | 1 | < 0.1% | |
| 13.2 | 1 | < 0.1% | |
| 13.1 | 2 | < 0.1% | |
| 13 | 11 | 0.1% | |
| 12.9 | 10 | 0.1% | |
| 12.8 | 6 | 0.1% | |
| 12.7 | 18 | 0.2% | |
| 12.6 | 27 | 0.3% | |
| 12.5 | 31 | 0.3% | |
| 12.4 | 24 | 0.2% |
| Distinct | 448 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1018.777892 |
|---|---|
| Minimum | 989.9 |
| Maximum | 1040.9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 83.7 KiB |
Quantile statistics
| Minimum | 989.9 |
|---|---|
| 5-th percentile | 1008.3 |
| Q1 | 1015.1 |
| median | 1018.7 |
| Q3 | 1022.5 |
| 95-th percentile | 1029.8 |
| Maximum | 1040.9 |
| Range | 51 |
| Interquartile range (IQR) | 7.4 |
Descriptive statistics
| Standard deviation | 6.317483212 |
|---|---|
| Coefficient of variation (CV) | 0.006201040738 |
| Kurtosis | 0.6284329164 |
| Mean | 1018.777892 |
| Median Absolute Deviation (MAD) | 3.7 |
| Skewness | -0.04544934965 |
| Sum | 10893792 |
| Variance | 39.91059413 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1018.8 | 115 | 1.1% | |
| 1019.6 | 111 | 1.0% | |
| 1020 | 103 | 1.0% | |
| 1019.2 | 99 | 0.9% | |
| 1018.4 | 98 | 0.9% | |
| 1017.8 | 98 | 0.9% | |
| 1020.8 | 97 | 0.9% | |
| 1017.6 | 95 | 0.9% | |
| 1017.1 | 91 | 0.9% | |
| 1018.7 | 89 | 0.8% | |
| 1016.7 | 89 | 0.8% | |
| 1019 | 89 | 0.8% | |
| 1017 | 88 | 0.8% | |
| 1018.3 | 88 | 0.8% | |
| 1017.4 | 88 | 0.8% | |
| 1017.9 | 87 | 0.8% | |
| 1020.4 | 87 | 0.8% | |
| 1020.2 | 86 | 0.8% | |
| 1016.5 | 86 | 0.8% | |
| 1016.2 | 86 | 0.8% | |
| 1017.2 | 86 | 0.8% | |
| 1015.4 | 86 | 0.8% | |
| 1016.6 | 83 | 0.8% | |
| 1021.2 | 82 | 0.8% | |
| 1016.4 | 81 | 0.8% | |
| Other values (423) | 8405 | 78.6% |
| Value | Count | Frequency (%) | |
| 989.9 | 1 | < 0.1% | |
| 991.5 | 1 | < 0.1% | |
| 993 | 1 | < 0.1% | |
| 993.7 | 1 | < 0.1% | |
| 994 | 1 | < 0.1% | |
| 994.5 | 1 | < 0.1% | |
| 994.7 | 1 | < 0.1% | |
| 995.4 | 1 | < 0.1% | |
| 995.5 | 1 | < 0.1% | |
| 995.8 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1040.9 | 1 | < 0.1% | |
| 1039.9 | 1 | < 0.1% | |
| 1038.9 | 1 | < 0.1% | |
| 1038.6 | 1 | < 0.1% | |
| 1038 | 1 | < 0.1% | |
| 1037.9 | 1 | < 0.1% | |
| 1037.8 | 2 | < 0.1% | |
| 1037.7 | 1 | < 0.1% | |
| 1037.4 | 1 | < 0.1% | |
| 1037.3 | 1 | < 0.1% |
| Distinct | 489 |
|---|---|
| Distinct (%) | 4.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1014.21652 |
|---|---|
| Minimum | 979.4 |
| Maximum | 1037 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 83.7 KiB |
Quantile statistics
| Minimum | 979.4 |
|---|---|
| 5-th percentile | 1001.2 |
| Q1 | 1010.2 |
| median | 1014.6 |
| Q3 | 1018.6 |
| 95-th percentile | 1025.8 |
| Maximum | 1037 |
| Range | 57.6 |
| Interquartile range (IQR) | 8.4 |
Descriptive statistics
| Standard deviation | 7.166732855 |
|---|---|
| Coefficient of variation (CV) | 0.007066275014 |
| Kurtosis | 0.8042313783 |
| Mean | 1014.21652 |
| Median Absolute Deviation (MAD) | 4.1 |
| Skewness | -0.3761146724 |
| Sum | 10845017.25 |
| Variance | 51.36205982 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1015.4 | 101 | 0.9% | |
| 1014.2 | 98 | 0.9% | |
| 1013.3 | 94 | 0.9% | |
| 1014.5 | 91 | 0.9% | |
| 1015.1 | 89 | 0.8% | |
| 1016.7 | 87 | 0.8% | |
| 1013.5 | 87 | 0.8% | |
| 1015 | 86 | 0.8% | |
| 1016.2 | 85 | 0.8% | |
| 1013.8 | 84 | 0.8% | |
| 1016.6 | 84 | 0.8% | |
| 1013.4 | 82 | 0.8% | |
| 1014.3 | 81 | 0.8% | |
| 1014.6 | 80 | 0.7% | |
| 1018.8 | 80 | 0.7% | |
| 1015.8 | 80 | 0.7% | |
| 1012.2 | 79 | 0.7% | |
| 1016.1 | 78 | 0.7% | |
| 1017.8 | 77 | 0.7% | |
| 1017.2 | 76 | 0.7% | |
| 1015.9 | 75 | 0.7% | |
| 1011.8 | 75 | 0.7% | |
| 1015.7 | 74 | 0.7% | |
| 1011.4 | 74 | 0.7% | |
| 1012.5 | 73 | 0.7% | |
| Other values (464) | 8623 | 80.6% |
| Value | Count | Frequency (%) | |
| 979.4 | 1 | < 0.1% | |
| 984.2 | 1 | < 0.1% | |
| 984.4 | 1 | < 0.1% | |
| 984.8 | 1 | < 0.1% | |
| 985.2 | 1 | < 0.1% | |
| 985.8 | 1 | < 0.1% | |
| 986.2 | 1 | < 0.1% | |
| 986.3 | 1 | < 0.1% | |
| 986.9 | 1 | < 0.1% | |
| 987.2 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1037 | 1 | < 0.1% | |
| 1036 | 1 | < 0.1% | |
| 1035.9 | 1 | < 0.1% | |
| 1035.4 | 1 | < 0.1% | |
| 1034.9 | 1 | < 0.1% | |
| 1034.6 | 1 | < 0.1% | |
| 1034.2 | 4 | < 0.1% | |
| 1034.1 | 1 | < 0.1% | |
| 1034 | 3 | < 0.1% | |
| 1033.9 | 1 | < 0.1% |
| Distinct | 323 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.78234359 |
|---|---|
| Minimum | 2.7 |
| Maximum | 37.4 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 83.7 KiB |
Quantile statistics
| Minimum | 2.7 |
|---|---|
| 5-th percentile | 12.1 |
| Q1 | 16 |
| median | 20.3 |
| Q3 | 25.8 |
| 95-th percentile | 30 |
| Maximum | 37.4 |
| Range | 34.7 |
| Interquartile range (IQR) | 9.8 |
Descriptive statistics
| Standard deviation | 5.86405181 |
|---|---|
| Coefficient of variation (CV) | 0.2821650881 |
| Kurtosis | -0.9237057063 |
| Mean | 20.78234359 |
| Median Absolute Deviation (MAD) | 4.8 |
| Skewness | 0.06999225618 |
| Sum | 222225.6 |
| Variance | 34.38710363 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 16 | 115 | 1.1% | |
| 15 | 111 | 1.0% | |
| 17 | 111 | 1.0% | |
| 18 | 109 | 1.0% | |
| 26 | 91 | 0.9% | |
| 15.5 | 90 | 0.8% | |
| 16.4 | 90 | 0.8% | |
| 17.2 | 88 | 0.8% | |
| 15.6 | 88 | 0.8% | |
| 23 | 88 | 0.8% | |
| 22 | 87 | 0.8% | |
| 14.6 | 87 | 0.8% | |
| 21 | 86 | 0.8% | |
| 28 | 86 | 0.8% | |
| 15.4 | 85 | 0.8% | |
| 27 | 85 | 0.8% | |
| 13 | 85 | 0.8% | |
| 15.8 | 84 | 0.8% | |
| 14 | 84 | 0.8% | |
| 17.4 | 84 | 0.8% | |
| 14.2 | 83 | 0.8% | |
| 29.4 | 81 | 0.8% | |
| 16.2 | 81 | 0.8% | |
| 28.5 | 77 | 0.7% | |
| 14.8 | 76 | 0.7% | |
| Other values (298) | 8461 | 79.1% |
| Value | Count | Frequency (%) | |
| 2.7 | 1 | < 0.1% | |
| 3.4 | 1 | < 0.1% | |
| 3.6 | 1 | < 0.1% | |
| 3.9 | 1 | < 0.1% | |
| 4.1 | 1 | < 0.1% | |
| 4.6 | 1 | < 0.1% | |
| 4.8 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 5.1 | 1 | < 0.1% | |
| 5.3 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 37.4 | 1 | < 0.1% | |
| 37.3 | 1 | < 0.1% | |
| 37 | 1 | < 0.1% | |
| 36.6 | 2 | < 0.1% | |
| 35.7 | 1 | < 0.1% | |
| 35.6 | 1 | < 0.1% | |
| 35.5 | 1 | < 0.1% | |
| 35.1 | 1 | < 0.1% | |
| 35 | 1 | < 0.1% | |
| 34.9 | 1 | < 0.1% |
| Distinct | 307 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.74555317 |
|---|---|
| Minimum | -3.6 |
| Maximum | 27.3 |
| Zeros | 5 |
| Zeros (%) | < 0.1% |
| Memory size | 83.7 KiB |
Quantile statistics
| Minimum | -3.6 |
|---|---|
| 5-th percentile | 3.2 |
| Q1 | 7.8 |
| median | 12.3 |
| Q3 | 18 |
| 95-th percentile | 22.6 |
| Maximum | 27.3 |
| Range | 30.9 |
| Interquartile range (IQR) | 10.2 |
Descriptive statistics
| Standard deviation | 6.211304442 |
|---|---|
| Coefficient of variation (CV) | 0.4873310998 |
| Kurtosis | -1.001901532 |
| Mean | 12.74555317 |
| Median Absolute Deviation (MAD) | 5.1 |
| Skewness | 0.04298506379 |
| Sum | 136288.2 |
| Variance | 38.58030287 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 10 | 136 | 1.3% | |
| 8 | 115 | 1.1% | |
| 7 | 110 | 1.0% | |
| 16 | 105 | 1.0% | |
| 9 | 102 | 1.0% | |
| 6 | 101 | 0.9% | |
| 19 | 90 | 0.8% | |
| 21 | 90 | 0.8% | |
| 7.8 | 88 | 0.8% | |
| 8.2 | 85 | 0.8% | |
| 12 | 83 | 0.8% | |
| 20 | 82 | 0.8% | |
| 18 | 82 | 0.8% | |
| 13 | 82 | 0.8% | |
| 9.4 | 79 | 0.7% | |
| 17 | 79 | 0.7% | |
| 15 | 78 | 0.7% | |
| 6.8 | 77 | 0.7% | |
| 8.4 | 75 | 0.7% | |
| 8.6 | 74 | 0.7% | |
| 11 | 74 | 0.7% | |
| 10.8 | 74 | 0.7% | |
| 5 | 73 | 0.7% | |
| 14.8 | 73 | 0.7% | |
| 7.2 | 73 | 0.7% | |
| Other values (282) | 8513 | 79.6% |
| Value | Count | Frequency (%) | |
| -3.6 | 1 | < 0.1% | |
| -3.5 | 1 | < 0.1% | |
| -3.3 | 1 | < 0.1% | |
| -2.7 | 1 | < 0.1% | |
| -2.6 | 2 | < 0.1% | |
| -2.4 | 2 | < 0.1% | |
| -2.2 | 3 | < 0.1% | |
| -2.1 | 3 | < 0.1% | |
| -2 | 1 | < 0.1% | |
| -1.9 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 27.3 | 1 | < 0.1% | |
| 27.2 | 1 | < 0.1% | |
| 26.8 | 1 | < 0.1% | |
| 26.7 | 1 | < 0.1% | |
| 26.1 | 3 | < 0.1% | |
| 26 | 3 | < 0.1% | |
| 25.9 | 3 | < 0.1% | |
| 25.8 | 2 | < 0.1% | |
| 25.7 | 1 | < 0.1% | |
| 25.6 | 2 | < 0.1% |
velocidad_media
Real number (ℝ≥0)
| Distinct | 54 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.21386328 |
|---|---|
| Minimum | 0 |
| Maximum | 68.04 |
| Zeros | 69 |
| Zeros (%) | 0.6% |
| Memory size | 83.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7.92 |
| Q1 | 11.88 |
| median | 14.04 |
| Q3 | 18 |
| 95-th percentile | 24.84 |
| Maximum | 68.04 |
| Range | 68.04 |
| Interquartile range (IQR) | 6.12 |
Descriptive statistics
| Standard deviation | 5.486014263 |
|---|---|
| Coefficient of variation (CV) | 0.3605931093 |
| Kurtosis | 4.712375203 |
| Mean | 15.21386328 |
| Median Absolute Deviation (MAD) | 2.88 |
| Skewness | 1.236521651 |
| Sum | 162681.84 |
| Variance | 30.0963525 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 12.96 | 1081 | 10.1% | |
| 11.88 | 1005 | 9.4% | |
| 14.04 | 987 | 9.2% | |
| 11.16 | 821 | 7.7% | |
| 16.92 | 784 | 7.3% | |
| 15.84 | 744 | 7.0% | |
| 15.12 | 740 | 6.9% | |
| 18 | 578 | 5.4% | |
| 10.08 | 544 | 5.1% | |
| 19.08 | 531 | 5.0% | |
| 9 | 348 | 3.3% | |
| 20.16 | 345 | 3.2% | |
| 7.92 | 313 | 2.9% | |
| 20.88 | 284 | 2.7% | |
| 21.96 | 253 | 2.4% | |
| 23.04 | 215 | 2.0% | |
| 6.84 | 185 | 1.7% | |
| 24.12 | 162 | 1.5% | |
| 24.84 | 127 | 1.2% | |
| 6.12 | 87 | 0.8% | |
| 0 | 69 | 0.6% | |
| 27 | 65 | 0.6% | |
| 25.92 | 64 | 0.6% | |
| 28.08 | 54 | 0.5% | |
| 5.04 | 42 | 0.4% | |
| Other values (29) | 265 | 2.5% |
| Value | Count | Frequency (%) | |
| 0 | 69 | 0.6% | |
| 1.08 | 1 | < 0.1% | |
| 2.16 | 3 | < 0.1% | |
| 2.88 | 1 | < 0.1% | |
| 3.96 | 14 | 0.1% | |
| 5.04 | 42 | 0.4% | |
| 6.12 | 87 | 0.8% | |
| 6.84 | 185 | 1.7% | |
| 7.92 | 313 | 2.9% | |
| 9 | 348 | 3.3% |
| Value | Count | Frequency (%) | |
| 68.04 | 1 | < 0.1% | |
| 60.12 | 1 | < 0.1% | |
| 56.16 | 1 | < 0.1% | |
| 51.12 | 1 | < 0.1% | |
| 50.04 | 2 | < 0.1% | |
| 47.88 | 3 | < 0.1% | |
| 47.16 | 4 | < 0.1% | |
| 46.08 | 1 | < 0.1% | |
| 45 | 3 | < 0.1% | |
| 43.92 | 2 | < 0.1% |
mes
Real number (ℝ≥0)
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.474703077 |
|---|---|
| Minimum | 1 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 83.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.432154778 |
|---|---|
| Coefficient of variation (CV) | 0.5300868221 |
| Kurtosis | -1.201472346 |
| Mean | 6.474703077 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.01180459393 |
| Sum | 69234 |
| Variance | 11.77968642 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) | |
| 3 | 930 | 8.7% | |
| 5 | 929 | 8.7% | |
| 4 | 900 | 8.4% | |
| 7 | 900 | 8.4% | |
| 8 | 899 | 8.4% | |
| 1 | 899 | 8.4% | |
| 10 | 898 | 8.4% | |
| 6 | 897 | 8.4% | |
| 9 | 870 | 8.1% | |
| 12 | 868 | 8.1% | |
| 11 | 866 | 8.1% | |
| 2 | 837 | 7.8% |
| Value | Count | Frequency (%) | |
| 1 | 899 | 8.4% | |
| 2 | 837 | 7.8% | |
| 3 | 930 | 8.7% | |
| 4 | 900 | 8.4% | |
| 5 | 929 | 8.7% | |
| 6 | 897 | 8.4% | |
| 7 | 900 | 8.4% | |
| 8 | 899 | 8.4% | |
| 9 | 870 | 8.1% | |
| 10 | 898 | 8.4% |
| Value | Count | Frequency (%) | |
| 12 | 868 | 8.1% | |
| 11 | 866 | 8.1% | |
| 10 | 898 | 8.4% | |
| 9 | 870 | 8.1% | |
| 8 | 899 | 8.4% | |
| 7 | 900 | 8.4% | |
| 6 | 897 | 8.4% | |
| 5 | 929 | 8.7% | |
| 4 | 900 | 8.4% | |
| 3 | 930 | 8.7% |
| Distinct | 30 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2006.221734 |
|---|---|
| Minimum | 1992 |
| Maximum | 2021 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 83.7 KiB |
Quantile statistics
| Minimum | 1992 |
|---|---|
| 5-th percentile | 1993 |
| Q1 | 1999 |
| median | 2006 |
| Q3 | 2014 |
| 95-th percentile | 2020 |
| Maximum | 2021 |
| Range | 29 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.541306453 |
|---|---|
| Coefficient of variation (CV) | 0.004257408994 |
| Kurtosis | -1.206180537 |
| Mean | 2006.221734 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.0119582195 |
| Sum | 21452529 |
| Variance | 72.95391592 |
| Monotocity | Increasing |
Histogram with fixed size bins (bins=30)
| Value | Count | Frequency (%) | |
| 1992 | 366 | 3.4% | |
| 2000 | 366 | 3.4% | |
| 2008 | 366 | 3.4% | |
| 2020 | 366 | 3.4% | |
| 2012 | 366 | 3.4% | |
| 2004 | 366 | 3.4% | |
| 1996 | 366 | 3.4% | |
| 2007 | 365 | 3.4% | |
| 1999 | 365 | 3.4% | |
| 2006 | 365 | 3.4% | |
| 1998 | 365 | 3.4% | |
| 2013 | 365 | 3.4% | |
| 2005 | 365 | 3.4% | |
| 1997 | 365 | 3.4% | |
| 2019 | 365 | 3.4% | |
| 2011 | 365 | 3.4% | |
| 2003 | 365 | 3.4% | |
| 1995 | 365 | 3.4% | |
| 2002 | 365 | 3.4% | |
| 1994 | 365 | 3.4% | |
| 2001 | 365 | 3.4% | |
| 1993 | 365 | 3.4% | |
| 2016 | 365 | 3.4% | |
| 2015 | 365 | 3.4% | |
| 2018 | 364 | 3.4% | |
| Other values (5) | 1562 | 14.6% |
| Value | Count | Frequency (%) | |
| 1992 | 366 | 3.4% | |
| 1993 | 365 | 3.4% | |
| 1994 | 365 | 3.4% | |
| 1995 | 365 | 3.4% | |
| 1996 | 366 | 3.4% | |
| 1997 | 365 | 3.4% | |
| 1998 | 365 | 3.4% | |
| 1999 | 365 | 3.4% | |
| 2000 | 366 | 3.4% | |
| 2001 | 365 | 3.4% |
| Value | Count | Frequency (%) | |
| 2021 | 181 | 1.7% | |
| 2020 | 366 | 3.4% | |
| 2019 | 365 | 3.4% | |
| 2018 | 364 | 3.4% | |
| 2017 | 362 | 3.4% | |
| 2016 | 365 | 3.4% | |
| 2015 | 365 | 3.4% | |
| 2014 | 361 | 3.4% | |
| 2013 | 365 | 3.4% | |
| 2012 | 366 | 3.4% |
lluvia
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 83.7 KiB |
| No | |
|---|---|
| Si |
| Value | Count | Frequency (%) | |
| No | 8459 | 79.1% | |
| Si | 2234 | 20.9% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Most occurring characters
| Value | Count | Frequency (%) | |
| N | 8459 | 39.6% | |
| o | 8459 | 39.6% | |
| S | 2234 | 10.4% | |
| i | 2234 | 10.4% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Uppercase Letter | 10693 | 50.0% | |
| Lowercase Letter | 10693 | 50.0% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| N | 8459 | 79.1% | |
| S | 2234 | 20.9% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| o | 8459 | 79.1% | |
| i | 2234 | 20.9% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 21386 | 100.0% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| N | 8459 | 39.6% | |
| o | 8459 | 39.6% | |
| S | 2234 | 10.4% | |
| i | 2234 | 10.4% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 21386 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| N | 8459 | 39.6% | |
| o | 8459 | 39.6% | |
| S | 2234 | 10.4% | |
| i | 2234 | 10.4% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | ID | fecha | precipitacion | horas_sol | presion_max | presion_min | temperatura_min | temperatura_max | velocidad_media | mes | anio | lluvia | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 0 | 1992-01-01 | 0.0 | 6.6 | 1037.8 | 1033.6 | 11.6 | 0.3 | 7.92 | 1 | 1992 | No |
| 1 | 1 | 1 | 1992-01-02 | 0.0 | 6.4 | 1038.6 | 1037.0 | 12.6 | 0.2 | 11.16 | 1 | 1992 | No |
| 2 | 2 | 2 | 1992-01-03 | 0.3 | 1.0 | 1037.3 | 1032.7 | 12.2 | 2.3 | 7.92 | 1 | 1992 | Si |
| 3 | 3 | 3 | 1992-01-04 | 0.0 | 5.7 | 1034.3 | 1031.4 | 12.5 | 1.3 | 11.16 | 1 | 1992 | No |
| 4 | 4 | 4 | 1992-01-05 | 0.0 | 6.8 | 1034.3 | 1032.0 | 12.4 | 0.2 | 11.16 | 1 | 1992 | No |
| 5 | 5 | 5 | 1992-01-06 | 0.0 | 6.6 | 1032.6 | 1029.8 | 11.2 | 0.1 | 18.00 | 1 | 1992 | No |
| 6 | 6 | 6 | 1992-01-07 | 0.0 | 0.0 | 1030.8 | 1026.1 | 10.4 | 1.0 | 7.92 | 1 | 1992 | No |
| 7 | 7 | 7 | 1992-01-08 | 0.0 | 0.0 | 1026.1 | 1018.2 | 13.3 | 6.5 | 18.00 | 1 | 1992 | No |
| 8 | 8 | 8 | 1992-01-09 | 1.3 | 0.0 | 1018.2 | 1011.2 | 12.8 | 8.1 | 11.16 | 1 | 1992 | Si |
| 9 | 9 | 9 | 1992-01-10 | 0.0 | 6.4 | 1019.9 | 1014.6 | 12.9 | 2.0 | 20.88 | 1 | 1992 | No |
Last rows
| df_index | ID | fecha | precipitacion | horas_sol | presion_max | presion_min | temperatura_min | temperatura_max | velocidad_media | mes | anio | lluvia | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10683 | 10765 | 10765 | 2021-06-22 | 0.3 | 11.4 | 1015.5 | 1009.0 | 26.0 | 21.9 | 15.84 | 6 | 2021 | Si |
| 10684 | 10766 | 10766 | 2021-06-23 | 2.4 | 6.1 | 1018.5 | 1014.4 | 26.3 | 17.6 | 16.92 | 6 | 2021 | Si |
| 10685 | 10767 | 10767 | 2021-06-24 | 0.0 | 11.8 | 1021.8 | 1018.0 | 25.9 | 18.0 | 15.12 | 6 | 2021 | No |
| 10686 | 10768 | 10768 | 2021-06-25 | 0.0 | 11.8 | 1021.6 | 1016.7 | 26.3 | 18.8 | 20.16 | 6 | 2021 | No |
| 10687 | 10769 | 10769 | 2021-06-26 | 0.0 | 8.9 | 1018.1 | 1013.2 | 26.7 | 19.7 | 15.12 | 6 | 2021 | No |
| 10688 | 10770 | 10770 | 2021-06-27 | 0.0 | 11.0 | 1014.7 | 1012.0 | 27.0 | 21.0 | 12.96 | 6 | 2021 | No |
| 10689 | 10771 | 10771 | 2021-06-28 | 0.0 | 9.8 | 1015.5 | 1011.4 | 27.2 | 20.1 | 12.96 | 6 | 2021 | No |
| 10690 | 10772 | 10772 | 2021-06-29 | 0.0 | 8.2 | 1017.8 | 1014.8 | 26.3 | 21.8 | 15.12 | 6 | 2021 | No |
| 10691 | 10773 | 10773 | 2021-06-30 | 0.0 | 9.0 | 1018.1 | 1016.0 | 26.5 | 23.0 | 18.00 | 6 | 2021 | No |
| 10692 | 10774 | 10774 | 2021-07-01 | 0.0 | 11.3 | 1017.7 | 1015.3 | 27.4 | 21.9 | 18.00 | 7 | 2021 | No |